$this->db->select('id'); $this->db->from('table'); $this->db->where($your_conditions); $num_results = $this->db->count_all_results();